package com.deyuanyun.pic.ctrl.excelImport;

import com.deyuanyun.pic.common.validator.annotations.DataValidate;
import com.deyuanyun.pic.ctrl.annotation.*;
import com.deyuanyun.pic.ctrl.util.AutoImportInterface;
import com.deyuanyun.pic.ctrl.validatefun.AutoPile;
import com.deyuanyun.pic.ctrl.validatefun.EnumValidata;
import com.deyuanyun.pic.ctrl.validatefun.PipeLineValidata;

import java.util.Date;

/**

    说明:Z:\excel\阴保有效性\1测试桩检测数据表（导入、导出）.xls

 **/
@DbTable(name="PIC_CTRL_EXINSP_CPTEST_STATION",startRow=5,sumCell=23,excelName="测试桩检测数据表.xls")
public class PicCtrlExinspCptestStationExcel implements AutoImportInterface
{

      /**
      * 管道名称
      */
      @Head( name="管道名称",row=2,cell=0)
      @DbFiled( name="PIPE_LINE_ID" ,type="CHAR")
      @DataValidate(notNull = true,myFunction = PipeLineValidata.class,myFunctionMessage="管道信息与项目要求管道不一致")
      private String pipeLineId;

      /**
      * 测试桩编号
      */
      @Head( name="测试桩编号",row=2,cell=1)
      @DbFiled( name="TEST_STATION_ID" ,type="CHAR")
      @DataValidate(notNull = true,myFunction = AutoPile.class,myFunctionMessage="测试桩不存在")
      private String testStationId;

      /**
      * 自然电位
      */
      @Head( name="自然电位",row=3,cell=2)
      @DbFiled( name="FREE_CORROSION_POTENTIAL" ,type="NUMBER")
      @DataValidate(type = Number.class,notNull = true)
      private String freeCorrosionPotential;

      /**
      * 最大值
      */
      @Head( name="最大值",row=4,cell=3)
      @DbFiled( name="ON_POTENTIAL_MAX" ,type="NUMBER")
      @DataValidate()
      private String onPotentialMax;

      /**
      * 最小值
      */
      @Head( name="最小值",row=4,cell=4)
      @DbFiled( name="ON_POTENTIAL_MIN" ,type="NUMBER")
      @DataValidate()
      private String onPotentialMin;

      /**
      * 平均值
      */
      @Head( name="平均值",row=4,cell=5)
      @DbFiled( name="ON_POTENTIAL_AVG" ,type="NUMBER")
      @DataValidate(type = Number.class,notNull = true)
      private String onPotentialAvg;

      /**
      * 最大值
      */
      @Head( name="最大值",row=4,cell=6)
      @DbFiled( name="OFF_POTENTIAL_MAX" ,type="NUMBER")
      @DataValidate()
      private String offPotentialMax;

      /**
      * 最小值
      */
      @Head( name="最小值",row=4,cell=7)
      @DbFiled( name="OFF_POTENTIAL_MIN" ,type="NUMBER")
      @DataValidate()
      private String offPotentialMin;

      /**
      * 平均值
      */
      @Head( name="平均值",row=4,cell=8)
      @DbFiled( name="OFF_POTENTIAL_AVG" ,type="NUMBER")
      @DataValidate()
      private String offPotentialAvg;

      /**
      * 交流电压（V）
      */
      @Head( name="交流电压（V）",row=2,cell=9)
      @DbFiled( name="AC_INTERFERENCE_VOLTAGE" ,type="NUMBER")
      @DataValidate(type = Number.class,notNull = true)
      private String acInterferenceVoltage;

      /**
      * 土壤电阻率（Ω﹒m）
      */
      @Head( name="土壤电阻率（Ω﹒m）",row=2,cell=10)
      @DbFiled( name="SOIL_RESISTIVITY" ,type="NUMBER")
      @DataValidate(type = Number.class,notNull = true)
      private String soilResistivity;

      /**
      * 交流电流密度（A/m2）
      */
      @Head( name="交流电流密度（A/m2）",row=2,cell=11)
      @DbFiled( name="AC_CURRENT_DENSITY" ,type="NUMBER")
      @DataValidate(type = Number.class,notNull = true)
      private String acCurrentDensity;

      /**
      * 交流干扰程度
      */
      @EnumVail(enumClass=com.deyuanyun.pic.ctrl.enumeration.CurrentFerenceEnum.class,valMethod="getVal")
      @Head( name="交流干扰程度",row=2,cell=12)
      @DbFiled( name="DEGREE_OF_AC_INTERFERENCE" ,type="VARCHAR2")
      @DataValidate(myFunctionMessage="可选值无对应值",myFunction = EnumValidata.class)
      private String degreeOfAcInterference;

      /**
      * 直流干扰
      */
      @EnumVail(enumClass=com.deyuanyun.pic.ctrl.enumeration.InterferenceSourceEnum.class,valMethod="getVal")
      @Head( name="直流干扰",row=2,cell=13)
      @DbFiled( name="DC_INTERFERENCE" ,type="VARCHAR2")
      @DataValidate(myFunctionMessage="可选值无对应值",myFunction = EnumValidata.class)
      private String dcInterference;

      /**
      * 土壤腐蚀等级
      */
      @EnumVail(enumClass=com.deyuanyun.pic.ctrl.enumeration.CurrentFerenceEnum.class,valMethod="getVal")
      @Head( name="土壤腐蚀等级",row=2,cell=14)
      @DbFiled( name="SOIL_CORROSION_GRADE" ,type="VARCHAR2")
      @DataValidate(myFunctionMessage="可选值无对应值",myFunction = EnumValidata.class)
      private String soilCorrosionGrade;

      /**
      * 阴保有效性评价
      */
      @EnumVail(enumClass=com.deyuanyun.pic.ctrl.enumeration.CathodicProtectionEvaluationEnum.class,valMethod="getVal")
      @Head( name="阴保有效性评价",row=2,cell=15)
      @DbFiled( name="PROTECTING_STATE" ,type="VARCHAR2")
      @DataValidate(notNull = true,myFunctionMessage="可选值无对应值",myFunction = EnumValidata.class)
      private String protectingState;

      /**
      * 测试桩完好情况
      */
      @EnumVail(enumClass=com.deyuanyun.pic.ctrl.enumeration.TestStationFineStatusEnum.class,valMethod="getVal")
      @Head( name="测试桩完好情况",row=2,cell=16)
      @DbFiled( name="TEST_STATION_FINE_STATUS" ,type="VARCHAR2")
      @DataValidate(notNull = true,myFunctionMessage="可选值无对应值",myFunction = EnumValidata.class)
      private String testStationFineStatus;

      /**
      * 检测日期
      */
      @Head( name="检测日期",row=2,cell=17)
      @DbFiled( name="TESTING_DATE" ,type="DATE")
      @DataValidate(type = Date.class,notNull = true)
      private String testingDate;

      /**
      * 检测单位
      */
      @Head( name="检测单位",row=2,cell=18)
      @DbFiled( name="TESTING_COMPANY" ,type="VARCHAR2")
      @DataValidate(notNull = true,lengthLimit="50",lengthLimitMessage = "长度不符合规范，最多50个字")
      private String testingCompany;

      /**
      * 记录人
      */
      @Head( name="记录人",row=2,cell=19)
      @DbFiled( name="RECORDER" ,type="VARCHAR2")
      @DataValidate(lengthLimit="50",lengthLimitMessage = "长度不符合规范，最多50个字")
      @AutoLoginUser
      private String recorder;

      /**
      * 记录时间
      */
      @Head( name="记录时间",row=2,cell=20)
      @DbFiled( name="RECORD_TIME" ,type="DATE")
      @DataValidate(type = Date.class)
      @AutoDate
      private String recordTime;

      /**
      * 备注
      */
      @Head( name="备注",row=2,cell=21)
      @DbFiled( name="REMARKS" ,type="VARCHAR2")
      @DataValidate(lengthLimit="50",lengthLimitMessage = "长度不符合规范，最多50个字")
      private String remarks;

      /**
      * id
      */
      @DbFiled( name="ID_")
      @AutoId
      private String id;

    @AutoExinspTask
    @DbFiled( name="EXINSP_TASK_ID",type="VARCHAR2")
    private String exinspTaskId;

    @DbFiled( name="DATA_STATED",type="VARCHAR2")
    private String dataStated;

    @DbFiled( name="IS_NEWEST",type="NUMBER")
    private String isNewset;

    public String getIsNewset() {
        return isNewset;
    }

    public void setIsNewset(String isNewset) {
        this.isNewset = isNewset;
    }

    public String getDataStated() {
        return dataStated;
    }

    public void setDataStated(String dataStated) {
        this.dataStated = dataStated;
    }

    public String getExinspTaskId() {
        return exinspTaskId;
    }

    public void setExinspTaskId(String exinspTaskId) {
        this.exinspTaskId = exinspTaskId;
    }



    public String getPipeLineId()
    {

        return  this.pipeLineId;
    }
    public void setPipeLineId(String pipeLineId)
    {

      this.pipeLineId=pipeLineId;
    }


    public String getTestStationId()
    {

        return  this.testStationId;
    }
    public void setTestStationId(String testStationId)
    {

      this.testStationId=testStationId;
    }


    public String getFreeCorrosionPotential()
    {

        return  this.freeCorrosionPotential;
    }
    public void setFreeCorrosionPotential(String freeCorrosionPotential)
    {

      this.freeCorrosionPotential=freeCorrosionPotential;
    }


    public String getOnPotentialMax()
    {

        return  this.onPotentialMax;
    }
    public void setOnPotentialMax(String onPotentialMax)
    {

      this.onPotentialMax=onPotentialMax;
    }


    public String getOnPotentialMin()
    {

        return  this.onPotentialMin;
    }
    public void setOnPotentialMin(String onPotentialMin)
    {

      this.onPotentialMin=onPotentialMin;
    }


    public String getOnPotentialAvg()
    {

        return  this.onPotentialAvg;
    }
    public void setOnPotentialAvg(String onPotentialAvg)
    {

      this.onPotentialAvg=onPotentialAvg;
    }


    public String getOffPotentialMax()
    {

        return  this.offPotentialMax;
    }
    public void setOffPotentialMax(String offPotentialMax)
    {

      this.offPotentialMax=offPotentialMax;
    }


    public String getOffPotentialMin()
    {

        return  this.offPotentialMin;
    }
    public void setOffPotentialMin(String offPotentialMin)
    {

      this.offPotentialMin=offPotentialMin;
    }

    public String getOffPotentialAvg() {
        return offPotentialAvg;
    }

    public void setOffPotentialAvg(String offPotentialAvg) {
        this.offPotentialAvg = offPotentialAvg;
    }

    public String getAcInterferenceVoltage()
    {

        return  this.acInterferenceVoltage;
    }
    public void setAcInterferenceVoltage(String acInterferenceVoltage)
    {

      this.acInterferenceVoltage=acInterferenceVoltage;
    }


    public String getSoilResistivity()
    {

        return  this.soilResistivity;
    }
    public void setSoilResistivity(String soilResistivity)
    {

      this.soilResistivity=soilResistivity;
    }


    public String getAcCurrentDensity()
    {

        return  this.acCurrentDensity;
    }
    public void setAcCurrentDensity(String acCurrentDensity)
    {

      this.acCurrentDensity=acCurrentDensity;
    }


    public String getDegreeOfAcInterference()
    {

        return  this.degreeOfAcInterference;
    }
    public void setDegreeOfAcInterference(String degreeOfAcInterference)
    {

      this.degreeOfAcInterference=degreeOfAcInterference;
    }


    public String getDcInterference()
    {

        return  this.dcInterference;
    }
    public void setDcInterference(String dcInterference)
    {

      this.dcInterference=dcInterference;
    }


    public String getSoilCorrosionGrade()
    {

        return  this.soilCorrosionGrade;
    }
    public void setSoilCorrosionGrade(String soilCorrosionGrade)
    {

      this.soilCorrosionGrade=soilCorrosionGrade;
    }


    public String getProtectingState()
    {

        return  this.protectingState;
    }
    public void setProtectingState(String protectingState)
    {

      this.protectingState=protectingState;
    }


    public String getTestStationFineStatus()
    {

        return  this.testStationFineStatus;
    }
    public void setTestStationFineStatus(String testStationFineStatus)
    {

      this.testStationFineStatus=testStationFineStatus;
    }


    public String getTestingDate()
    {

        return  this.testingDate;
    }
    public void setTestingDate(String testingDate)
    {

      this.testingDate=testingDate;
    }


    public String getTestingCompany()
    {

        return  this.testingCompany;
    }
    public void setTestingCompany(String testingCompany)
    {

      this.testingCompany=testingCompany;
    }


    public String getRecorder()
    {

        return  this.recorder;
    }
    public void setRecorder(String recorder)
    {

      this.recorder=recorder;
    }


    public String getRecordTime()
    {

        return  this.recordTime;
    }
    public void setRecordTime(String recordTime)
    {

      this.recordTime=recordTime;
    }


    public String getRemarks()
    {

        return  this.remarks;
    }
    public void setRemarks(String remarks)
    {

      this.remarks=remarks;
    }


    public String getId()
    {

        return  this.id;
    }
    public void setId(String id)
    {

      this.id=id;
    }





}